{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Fiscal Report","Data Tables","Products","Joxxer","Glanding","Isoxa","Lego Co.","S.H.I.E.L.D.","Greendale","OfficeMax","Cougar Creations"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Fiscal Report","index":0,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,5,4,10],[6,5,6,10]]}
[]
[null,null,null,null,null,"Company Fiscal Report"]
[]
[]
[]
[]
[null,null,null,null,null,"Produced by: Dan Jones, John Somppi, and Stewart Perry"]

{"sheet":"Data Tables","index":1,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,2,5,4],[17,0,17,4],[34,0,34,4],[11,1,11,4]]}
[]
[]
[null,null,"REVENUE                                                             AND EARNINGS                                                 FOR THE YEAR"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Net Revenue Per Quarter"]
[null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,72954.55,31818.17,37937.949999999997,60559.48]
[]
[]
[]
["Quarterly Earnings Per Product"]
["Products","Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
["Paper-8.5x11 20 lb bond (ream)",8065.97,7758.6,7902.18,7891.22]
["Paper-8.5x11 32 lb brochure (ream)",4751.2299999999996,1330.4,2136.04,3362.96]
["Paper-8.5x11 cardstock 90 lb (ream)",12715.09,6537.72,2925.47,4515.3599999999997]
["Commercial #10 envelopes (ream)",2384.58,1877.38,3217.2,6429.28]
["5.5 Baronial envelopes (ream)",10302.86,2649.92,9398.1200000000008,16775.16]
["1\" 3-ring binder",1018.19,416.64,221.24,355.24]
["2.5\" 3-ring binder",570.6,599.4,380.4,998.46]
["Dunder-Mifflin printer",16090,2100,10200,600]
["Classic stapler",495.3,1823.97,771.3,3663.11]
["Asian Stationery (30 sheets)",15538.93,3500.5,0,13638.48]
["Stamps (20)",1021.8,3223.64,786,2330.1999999999998]
[]
[]
[]
[]
["Quarterly Earnings Per Client"]
["Clients","Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
["Joxxer",13320,2815,840,6809.97]
["Glanding",6509.4,4198.79,1683.78,19195]
["Isoxa",3313.61,3496.88,1980.06,6135.16]
["Lego Co.",9786.2999999999993,1525.74,5001.53,3272.86]
["S.H.I.E.L.D",6103.57,2572.3200000000002,3256.64,5992.91]
["Greendale Community College",11297.14,131.56,5602.88,4203.46]
["OfficeMax",9858.02,4272.3999999999996,17331.96,5879.35]
["Microsoft",12766.52,12805.48,2241.1,9070.76]

{"sheet":"Products","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Product List"]
[null,null,"Selling"]
["Product","Cost to make","Unit Price","Bulk Price (10 reams)"]
["Paper-8.5x11 20 lb bond (ream)",{"$f":"C4*0.2","v":1.9960000000000002},9.98,7.5]
["Paper-8.5x11 32 lb brochure (ream)",{"$f":"C5*0.2","v":2.5960000000000001},12.98,9.6]
["Paper-8.5x11 cardstock 90 lb (ream)",2.8980000000000001,14.49,10.5]
["Commercial #10 envelopes (ream)",2.298,11.49,9.7799999999999994]
["5.5 Baronial envelopes (ream)",9.9980000000000011,49.99,37.5]
["1\" 3-ring binder",0.39800000000000002,1.99,1.7]
["2.5\" 3-ring binder",0.59800000000000009,2.99,2.5]
["Dunder-Mifflin printer",10,50,45]
["Classic stapler",0.99800000000000011,4.99,4.3]
["Asian Stationery (30 sheets)",3.9979999999999998,19.989999999999998,18]
["Stamps (20)",1.99,9.9499999999999993,9.85]

{"sheet":"Joxxer","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,1,26,3],[10,1,10,6],[11,0,11,1],[21,1,21,3],[12,0,12,1],[34,1,34,3],[35,1,35,3],[36,1,36,3],[14,0,14,1],[15,0,15,1],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[27,1,27,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","Joxxer"]
["Years as Client:",null,1]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":0}]
[]
["Gross Sales:",null,8283.7999999999993]
["Net Sales:",null,6551.4480000000003]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["March","Dunder-Mifflin printer",null,null,50,10,333,{"$f":"discountsale(E23,G23,discount)","v":16650},{"$f":"netprofit(F23,G23,H23)","v":13320}]
["June","Paper-8.5x11 20 lb bond (ream)",null,null,{"$f":"saleprice(B24,G24)","v":7.5},2,130,{"$f":"discountsale(E24,G24,discount)","v":975},{"$f":"netprofit(F24,G24,H24)","v":715}]
["June","Dunder-Mifflin printer",null,null,{"$f":"saleprice(B25,G25)","v":45},10,60,2700,2100]
["September","Dunder-Mifflin printer",null,null,50,10,21,1050,840]
["October","Paper-8.5x11 20 lb bond (ream)",null,null,9.98,2,51,508.98,406.98]
["October","Classic stapler",null,null,4.99,1,324,1616.76,1292.76]
["December","Dunder-Mifflin printer",null,null,50,10,15,750,600]
["December","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,2,300,2250,1650]
["December","Commercial #10 envelopes (ream)",null,null,11.49,2.2999999999999998,225,{"$f":"discountsale(E31,G31,discount)","v":2585.25},2067.75]
["December","Classic stapler",null,null,4.3,0.998,240,{"$f":"discountsale(E32,G32,discount)","v":1032},{"$f":"netprofit(F32,G32,H32)","v":792.48}]

{"sheet":"Glanding","index":4,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,1,26,3],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[15,0,15,1],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","Glanding"]
["Years as Client:",null,3]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":3.9999999999999994E-2}]
[]
["Gross Sales:",null,9064.0400000000009]
["Net Sales:",null,7155.64]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["February","Paper-8.5x11 32 lb brochure (ream)",null,null,9.98,2,54,{"$f":"discountsale(E23,G23,discount)","v":538.92000000000007},{"$f":"netprofit(F23,G23,H23)","v":430.91999999999996}]
["February","5.5 Baronial envelopes (ream)",null,null,49.99,10,152,7598.4800000000005,{"$f":"netprofit(F24,G24,H24)","v":6078.48}]
["April","2.5\" 3-ring binder",null,null,2.99,0.6,148,442.52000000000004,353.71999999999997]
["May","Classic stapler",null,null,4.99,1,333,1661.67,1328.67]
["June","Paper-8.5x11 32 lb brochure (ream)",null,null,{"$f":"saleprice(B27,G27)","v":9.6},2.6,90,864,630]
["June","Stamps (20)",null,null,{"$f":"saleprice(B28,G28)","v":9.85},1.99,240,2364,1886.4]
["September","Paper-8.5x11 20 lb bond (ream)",null,null,9.98,2,211,2105.7800000000002,1683.7800000000002]
["October","Asian Stationery (30 sheets)",null,null,18,4,330,5940,4620]
["November","5.5 Baronial envelopes (ream)",null,null,37.5,10,330,12375,9075]
["December","5.5 Baronial envelopes (ream)",null,null,37.5,10,200,7500,5500]

{"sheet":"Isoxa","index":5,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,1,26,3],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[15,0,15,1],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","Isoxa"]
["Years as Client:",null,12]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":0.22}]
[]
["Gross Sales:",null,9064.0400000000009]
["Net Sales:",null,7155.64]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["January","Paper-8.5x11 20 lb bond (ream)",null,null,9.98,2,100,{"$f":"discountsale(E23,G23,discount)","v":998},{"$f":"netprofit(F23,G23,H23)","v":798}]
["January","Paper-8.5x11 cardstock 90 lb (ream)",null,null,14.49,2.9,79,1144.71,{"$f":"netprofit(F24,G24,H24)","v":915.61}]
["February","Dunder-Mifflin printer",null,null,50,10,40,2000,1600]
["May","Commercial #10 envelopes (ream)",null,null,{"$f":"saleprice(B26,G26)","v":11.49},2.2999999999999998,76,873.24,698.44]
["May","Stamps (20)",null,null,{"$f":"saleprice(B27,G27)","v":9.9499999999999993},1.99,89,885.55,708.43999999999994]
["June","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,2,380,2850,2090]
["August","1\" 3-ring binder",null,null,1.7,0.4,50,85,65]
["August","Classic stapler",null,null,4.99,1,94,469.06,375.06]
["September","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,2,280,2100,1540]
["October","Paper-8.5x11 cardstock 90 lb (ream)",null,null,14.49,2.9,324,4694.76,3755.1600000000003]
["November","Asian Stationery (30 sheets)",null,null,18,4,170,3060,2380]

{"sheet":"Lego Co.","index":6,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,0,15,1],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[32,1,32,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[44,1,44,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","Lego Co."]
["Years as Client:",null,2]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":0.02}]
[]
["Gross Sales:",null,11291.45]
["Net Sales:",null,8850.7199999999993]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["January","1\" 3-ring binder",null,null,{"$f":"saleprice(B23,G23)","v":1.99},0.39800000000000002,425,{"$f":"discountsale(E23,G23,discount)","v":845.75},{"$f":"netprofit(F23,G23,H23)","v":676.6}]
["April","Paper-8.5x11 cardstock 90 lb (ream)",null,null,{"$f":"saleprice(B24,G24)","v":10.5},2.8980000000000001,60,630,{"$f":"netprofit(F24,G24,H24)","v":456.12}]
["July","Paper-8.5x11 32 lb brochure (ream)",null,null,9.6,2.5960000000000001,90,864,630.36]
["September","Stamps (20)",null,null,9.85,1.99,100,985,786]
["February","Asian Stationery (30 sheets)",null,null,19.989999999999998,3.9980000000000002,352,7036.48,5629.1839999999993]
["May","Classic stapler",null,null,4.3,0.998,120,516,396.24]
["September","Dunder-Mifflin printer",null,null,50,10,45,2250,1800]
["December","2.5\" 3-ring binder",null,null,2.99,0.59799999999999998,322,962.78000000000009,770.22399999999993]
["January","1\" 3-ring binder",null,null,1.99,0.39800000000000002,51,101.49,81.191999999999993]
["March","5.5 Baronial envelopes (ream)",null,null,49.99,9.9979999999999993,85,4249.1500000000005,3399.3199999999997]
["June","Commercial #10 envelopes (ream)",null,null,9.7799999999999994,2.298,90,880.19999999999993,673.38]
["August","Paper-8.5x11 cardstock 90 lb (ream)",null,null,14.49,2.8980000000000001,154,2231.46,1785.1680000000001]
["October","Paper-8.5x11 32 lb brochure (ream)",null,null,12.98,2.5960000000000001,135,1752.3,1401.84]
["November","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,200,1500,1100.8]

{"sheet":"S.H.I.E.L.D.","index":7,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[15,0,15,1],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[32,1,32,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[44,1,44,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","S.H.I.E.L.D"]
["Years as Client:",null,6]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":9.9999999999999992E-2}]
[]
["Gross Sales:",null,1493.91]
["Net Sales:",null,1068.48]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["January","1\" 3-ring binder",null,null,{"$f":"saleprice(B23,G23)","v":1.7},0.39800000000000002,200,{"$f":"discountsale(E23,G23,discount)","v":340},{"$f":"netprofit(F23,G23,H23)","v":260.39999999999998}]
["January","Paper-8.5x11 cardstock 90 lb (ream)",null,null,{"$f":"saleprice(B24,G24)","v":14.49},2.8980000000000001,345,4999.05,{"$f":"netprofit(F24,G24,H24)","v":3999.2400000000002}]
["February","Paper-8.5x11 32 lb brochure (ream)",null,null,9.6,2.5960000000000001,90,864,630.36]
["February","Paper-8.5x11 20 lb bond (ream)",null,null,9.98,1.996,152,1516.96,1213.568]
["April","Commercial #10 envelopes (ream)",null,null,11.49,2.298,55,631.95000000000005,505.56000000000006]
["April","5.5 Baronial envelopes (ream)",null,null,37.5,9.9979999999999993,60,2250,1650.1200000000001]
["May","1\" 3-ring binder",null,null,1.7,0.39800000000000002,320,544,416.64]
["July","2.5\" 3-ring binder",null,null,2.5,0.59799999999999998,200,500,380.4]
["July","Dunder-Mifflin printer",null,null,50,10,62,3100,2480]
["September","Classic stapler",null,null,4.3,0.998,120,516,396.24]
["October","Asian Stationery (30 sheets)",null,null,19.989999999999998,3.9980000000000002,85,1699.1499999999999,1359.3200000000002]
["October","Stamps (20)",null,null,9.9499999999999993,1.99,115,1144.25,915.4]
["November","Commercial #10 envelopes (ream)",null,null,9.7799999999999994,2.298,90,880.19999999999993,673.38]
["December","Classic stapler",null,null,4.99,0.998,124,618.76,495.00799999999998]
["December","Paper-8.5x11 32 lb brochure (ream)",null,null,9.6,2.5960000000000001,200,1920,1400.8]
["Spetember","Commercial #10 envelopes (ream)",null,null,11.49,2.298,125,1436.25,1149]

{"sheet":"Greendale","index":8,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,0,15,1],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[32,1,32,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[44,1,44,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","Greendale Community College"]
["Years as Client:",null,7]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":0.12000000000000001}]
[]
["Gross Sales:",null,5107.8599999999997]
["Net Sales:",null,3760.36]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["December","1\" 3-ring binder",null,null,{"$f":"saleprice(B23,G23)","v":1.99},0.39800000000000002,125,{"$f":"discountsale(E23,G23,discount)","v":248.75},{"$f":"netprofit(F23,G23,H23)","v":199}]
["February","Paper-8.5x11 cardstock 90 lb (ream)",null,null,{"$f":"saleprice(B24,G24)","v":14.49},2.8980000000000001,345,4999.05,{"$f":"netprofit(F24,G24,H24)","v":3999.2400000000002}]
["August","Paper-8.5x11 32 lb brochure (ream)",null,null,12.98,2.5960000000000001,145,1882.1000000000001,1505.6799999999998]
["November","Stamps (20)",null,null,9.85,1.99,100,985,786]
["January","Asian Stationery (30 sheets)",null,null,19.989999999999998,3.9980000000000002,357,7136.4299999999994,5709.1440000000002]
["July","Dunder-Mifflin printer",null,null,50,10,22,1100,880]
["October","Classic stapler",null,null,4.99,0.998,172,858.28000000000009,686.62400000000002]
["March","Paper-8.5x11 32 lb brochure (ream)",null,null,12.98,2.5960000000000001,153,1985.94,1588.752]
["September","Commercial #10 envelopes (ream)",null,null,11.49,2.298,239,2746.11,2196.8879999999999]
["December","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,460,3450,2531.84]
["May","2.5\" 3-ring binder",null,null,2.99,0.59799999999999998,55,164.45000000000002,131.56]
["August","Commercial #10 envelopes (ream)",null,null,11.49,2.298,111,1275.3900000000001,1020.3120000000001]

{"sheet":"OfficeMax","index":9,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[52,1,52,3],[53,1,53,3],[54,1,54,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[15,0,15,1],[21,1,21,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","OfficeMax"]
["Years as Client:",null,3]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":3.9999999999999994E-2}]
[]
["Gross Sales:",null,47434.78]
["Net Sales:",null,36037.171999999999]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["January","Paper-8.5x11 20 lb bond (ream)",null,null,{"$f":"saleprice(B23,G23)","v":7.5},1.996,600,{"$f":"discountsale(E23,G23,discount)","v":4500},{"$f":"netprofit(F23,G23,H23)","v":3302.4}]
["January","Dunder-Mifflin printer",null,null,{"$f":"saleprice(B24,G24)","v":45},10,30,1350,{"$f":"netprofit(F24,G24,H24)","v":1050}]
["February","Commercial #10 envelopes (ream)",null,null,{"$f":"saleprice(B25,G25)","v":11.49},2.298,235,2700.15,2160.12]
["February","Paper-8.5x11 32 lb brochure (ream)",null,null,{"$f":"saleprice(B26,G26)","v":9.6},2.5960000000000001,300,2880,{"$f":"netprofit(F26,G26,H26)","v":2101.1999999999998}]
["February","2.5\" 3-ring binder",null,null,{"$f":"saleprice(B27,G27)","v":2.5},0.59799999999999998,150,375,285.3]
["February","Classic stapler",null,null,4.3,0.998,100,430,330.2]
["February","Stamps (20)",null,null,9.85,1.99,80,788,628.79999999999995]
["June","Paper-8.5x11 cardstock 90 lb (ream)",null,null,10.5,2.8980000000000001,200,2100,{"$f":"netprofit(F30,G30,H30)","v":1520.3999999999999}]
["June","Paper-8.5x11 20 lb bond (ream)",null,null,{"$f":"saleprice(B31,G31)","v":7.5},1.996,500,3750,2752]
["July","5.5 Baronial envelopes (ream)",null,null,{"$f":"saleprice(B32,G32)","v":49.99},9.9979999999999993,235,11747.65,{"$f":"netprofit(F32,G32,H32)","v":9398.119999999999}]
["July","1\" 3-ring binder",null,null,{"$f":"saleprice(B33,G33)","v":1.7},0.39800000000000002,120,204,156.24]
["August","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,650,4875,3577.6]
["August","Dunder-Mifflin printer",null,null,45,10,120,5400,4200]
["October","Classic stapler",null,null,4.3,0.998,60,258,198.12]
["October","Asian Stationery (30 sheets)",null,null,18,3.9980000000000002,200,3600,2800.4]
["December","Commercial #10 envelopes (ream)",null,null,11.49,2.298,146,1677.54,1342.0319999999999]
["December","1\" 3-ring binder",null,null,1.7,0.39800000000000002,80,136,104.16]
["December","2.5\" 3-ring binder",null,null,2.5,0.59799999999999998,60,150,{"$f":"netprofit(F40,G40,H40)","v":114.12}]
["December","Paper-8.5x11 32 lb brochure (ream)",null,null,9.6,2.5960000000000001,80,768,560.31999999999994]
["December","Paper-8.5x11 cardstock 90 lb (ream)",null,null,10.5,2.8980000000000001,100,1050,760.19999999999993]

{"sheet":"Cougar Creations","index":10,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,1,46,3],[47,1,47,3],[48,1,48,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[10,1,10,6],[11,0,11,1],[12,0,12,1],[14,0,14,1],[15,0,15,1],[21,1,21,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Client Name:","Microsoft"]
["Years as Client:",null,1]
["Bulk Purchase Discount:",null,{"$f":"(C12*0.02)-0.02","v":0}]
[]
["Gross Sales:",null,49129.9]
["Net Sales:",null,36883.86]
[]
[]
[]
[]
["Products Sold"]
["Month of Sale","Product",null,null,"Sale Price","Product Cost","Quantity","Total Sale","Net Profit"]
["January","Dunder-Mifflin printer",null,null,{"$f":"saleprice(B23,G23)","v":50},10,3,{"$f":"discountsale(E23,G23,discount)","v":150},{"$f":"netprofit(F23,G23,H23)","v":120}]
["January","2.5\" 3-ring binder",null,null,{"$f":"saleprice(B24,G24)","v":2.5},0.59799999999999998,150,375,{"$f":"netprofit(F24,G24,H24)","v":285.3}]
["January","Classic stapler",null,null,4.3,0.998,50,215,165.1]
["January","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,500,3750,2752]
["January","Paper-8.5x11 cardstock 90 lb (ream)",null,null,10.5,2.8980000000000001,500,5250,3801]
["January","Asian Stationery (30 sheets)",null,null,18,3.9980000000000002,300,5400,4200.6000000000004]
["January","5.5 Baronial envelopes (ream)",null,null,37.5,9.9979999999999993,30,1125,825.06000000000006]
["February","Stamps (20)",null,null,9.85,1.99,50,492.5,393]
["February","Commercial #10 envelopes (ream)",null,null,9.7799999999999994,2.298,30,293.39999999999998,224.45999999999998]
["April","2.5\" 3-ring binder",null,null,2.5,0.59799999999999998,60,150,114.12]
["April","Classic stapler",null,null,4.3,0.998,30,129,99.06]
["April","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,400,3000,2201.6]
["April","Paper-8.5x11 cardstock 90 lb (ream)",null,null,10.5,2.8980000000000001,600,6300,4561.2]
["April","Asian Stationery (30 sheets)",null,null,18,3.9980000000000002,250,4500,3500.5]
["April","5.5 Baronial envelopes (ream)",null,null,49.99,9.9979999999999993,25,1249.75,999.80000000000007]
["June","Stamps (20)",null,null,9.85,1.99,80,788,628.79999999999995]
["June","Paper-8.5x11 32 lb brochure (ream)",null,null,9.6,2.5960000000000001,100,960,700.4]
["September","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,200,1500,1100.8]
["September","Paper-8.5x11 cardstock 90 lb (ream)",null,null,10.5,2.8980000000000001,150,{"$f":"discountsale(E41,G41,discount)","v":1575},1140.3]
["October","Classic stapler",null,null,4.3,0.998,60,258,198.12]
["October","Asian Stationery (30 sheets)",null,null,19.989999999999998,3.9980000000000002,155,3098.45,2478.7599999999998]
["November","2.5\" 3-ring binder",null,null,2.5,0.59799999999999998,60,150,114.12]
["November","1\" 3-ring binder",null,null,1.7,0.39800000000000002,40,68,52.08]
["December","5.5 Baronial envelopes (ream)",null,null,37.5,9.9979999999999993,80,3000,2200.16]
["December","Commercial #10 envelopes (ream)",null,null,9.7799999999999994,2.298,160,1564.8,1197.1199999999999]
["December","Paper-8.5x11 20 lb bond (ream)",null,null,7.5,1.996,400,3000,2201.6]
["December","Stamps (20)",null,null,9.85,1.99,80,788,628.79999999999995]